package org.example.volunteerend.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.example.volunteerend.entity.ProjectCategory;

@Mapper
public interface ProjectCategoryMapper {
    @Select("SELECT category_id, category_name, description, icon_url FROM project_categories ORDER BY category_id")
    List<ProjectCategory> findAll();
    
    @Select("SELECT category_id, category_name, description, icon_url FROM project_categories WHERE category_id = #{categoryId}")
    ProjectCategory findById(Integer categoryId);
} 